package com.bossly.metro;

public final class Tables {
	public static final String CityTable = "Cities";
	public static final String CrossingsTable = "Crossings";
	public static final String LinesTable = "Lines";
	public static final String StationsTable = "Stations";

	/**
	 * The class represents database table "cities".
	 */
	public static final class Cities {
		/* Constants id, name */
		public static final String ID = "_id";
		public static final String NAME = "Name";
		public static final String LAT = "lat";
		public static final String LNG = "lng";

		public static final int ID_INDEX = 0;
		public static final int NAME_INDEX = 1;
		public static final int LAT_INDEX = 2;
		public static final int LNG_INDEX = 3;

		public static final String[] COLUMNS = new String[] { ID, NAME, LAT,
				LNG };
	}

	/**
	 * The class represents database table "crossings".
	 */
	public static final class Crossings {
		public static final String ID = "_id";
		public static final String FROM_ID = "FromStationId";
		public static final String TO_ID = "ToStationId";

		public static final int ID_INDEX = 0;
		public static final int FROM_INDEX = 1;
		public static final int TO_INDEX = 2;

		/** The Constant COLUMNS. */
		public static final String[] COLUMNS = new String[] { ID, FROM_ID,
				TO_ID };
	}

	/**
	 * The class represents database table "Lines".
	 */
	public static final class Lines {
		public static final String ID = "_id";
		public static final String NAME = "Name";
		public static final String CITY_ID = "CityId";

		public static final int ID_INDEX = 0;
		public static final int NAME_INDEX = 1;
		public static final int CITY_INDEX = 2;

		/** The Constant COLUMNS. */
		public static final String[] COLUMNS = new String[] { ID, NAME, CITY_ID };
	}

	/**
	 * The class represents database table "Lines".
	 */
	public static final class Stations {
		public static final String ID = "_id";
		public static final String NAME = "Name";
		public static final String NEXT_ID = "NextStationId";
		public static final String PREV_ID = "PrevStationId";
		public static final String LINE_ID = "LineId";
		public static final String LAT = "lat";
		public static final String LNG = "lng";
		public static final String LOC_X = "locx";
		public static final String LOC_Y = "locy";

		public static final int ID_INDEX = 0;
		public static final int NAME_INDEX = 1;
		public static final int NEXT_INDEX = 2;
		public static final int PREV_INDEX = 3;
		public static final int LINE_INDEX = 4;
		public static final int LAT_INDEX = 5;
		public static final int LNG_INDEX = 6;
		public static final int LOCX_INDEX = 7;
		public static final int LOCY_INDEX = 8;

		/** The Constant COLUMNS. */
		public static final String[] COLUMNS = new String[] { ID, NAME,
				NEXT_ID, PREV_ID, LINE_ID, LAT, LNG, LOC_X, LOC_Y };
	}
}
